String Functions in Tableau – Complete Detailed Notes

String functions in Tableau are used to manipulate, clean, search, extract, format, and transform text data. They help analysts prepare customer names, product descriptions, email addresses, order IDs, city names, categories, and other text fields for analysis and visualization.

Course: JustAcademy Tableau Training

Course Demo: Register for a Tableau Course Demo

1. Learning Objectives

After completing this topic, you will be able to:

• Understand string data and string functions in Tableau.
• Convert text to uppercase, lowercase, and proper case.
• Remove unwanted spaces and clean inconsistent text.
• Extract characters from the beginning, middle, or end of a string.
• Find text, check whether a string contains a word, and identify text patterns.
• Split names, email addresses, product codes, and other delimited values.
• Replace text and create standardized categories.
• Use regular expressions for advanced text cleaning.
• Create calculated fields and use them in dashboards.

2. What Is a String in Tableau?

A string is a sequence of characters representing text. It may contain letters, numbers, spaces, punctuation marks, or special characters.

Examples of string values include:

• "Mumbai"
• "Tableau Training"
• "Customer123"
• "[email protected]"
• "ORD-2026-105"

In Tableau, a string field is generally represented by the Abc data-type icon in the Data pane. String functions operate on text expressions and can return either text, numbers, or Boolean values, depending on the function.

Example Dataset

This dataset contains inconsistent capitalization, spaces, and structured codes. String functions can clean these values and extract useful information.

3. What Are String Functions?

String functions are built-in calculation functions that perform operations on text. Instead of manually editing thousands of rows, you can create calculated fields that automatically transform values for analysis.

General syntax:

FUNCTION_NAME(string_expression)

For functions that require additional arguments:

FUNCTION_NAME(string_expression, argument1, argument2)

For example:

UPPER([City])

If the City field contains mumbai, the result is MUMBAI.

Why Are String Functions Important?

• Data cleaning: Remove unwanted spaces and standardize text.
• Data extraction: Extract product categories, codes, names, or domains.
• Data validation: Check whether values contain expected characters.
• Data categorization: Group text values into consistent categories.
• Dashboard development: Create labels, tooltips, and calculated dimensions.
• Data preparation: Make inconsistent source values easier to analyze.

4. Common String Functions in Tableau

5. UPPER() Function

The UPPER() function converts all letters in a string to uppercase. It is useful when text values have inconsistent capitalization.

Syntax:

UPPER(string)

Example:

UPPER("Tableau Training")

Output: TABLEAU TRAINING

Using a Field

UPPER([City])

If City contains mumbai, the calculated field returns MUMBAI.

Practical Uses

• Standardizing city names.
• Creating consistent product labels.
• Comparing text after normalizing capitalization.
• Making category labels consistent across source records.

6. LOWER() Function

LOWER() converts all letters in a string to lowercase. It is useful for standardizing email addresses, usernames, and other text identifiers.

Syntax:

LOWER(string)

Example:

LOWER("[email protected]")

Output: [email protected]

Field calculation:

LOWER([Email])

This creates a consistent lowercase representation of email values. It does not verify whether an email address exists or belongs to a real person.

7. PROPER() Function

PROPER() capitalizes the first letter of each word and converts the remaining letters to lowercase. Spaces and many punctuation characters act as word separators.

Syntax:

PROPER(string)

Example:

PROPER("rahul sharma")

Output: Rahul Sharma

Another example:

PROPER("CUSTOMER SERVICE TEAM")

Output: Customer Service Team

Practical calculation:

PROPER(TRIM([Customer Name]))

This first removes leading and trailing spaces and then standardizes capitalization. Note that PROPER() may not correctly preserve every person's preferred name formatting, abbreviations, or brand capitalization. It is also supported only for certain data sources and extracts, so check compatibility with your connection.

8. TRIM(), LTRIM(), and RTRIM() Functions

Extra spaces can make values look identical while causing inconsistent grouping or comparison. These functions remove spaces from different parts of a string.

8.1 TRIM()

Removes leading and trailing spaces.

TRIM("  Mumbai  ")

Output: Mumbai

8.2 LTRIM()

Removes spaces from the beginning of a string.

LTRIM("  Mumbai  ")

Output: Mumbai

8.3 RTRIM()

Removes spaces from the end of a string.

RTRIM("  Mumbai  ")

Output: Mumbai

Comparison Table

Practical Example

UPPER(TRIM([City]))

If the original value is Mumbai , the result is MUMBAI.

Important: TRIM(), LTRIM(), and RTRIM() primarily remove ordinary leading or trailing spaces. They do not necessarily remove every kind of whitespace or invisible character found in imported data.

9. LEN() Function

LEN() returns the number of characters in a string.

Syntax:

LEN(string)

Examples:

LEN("Tableau")

Output: 7

LEN("New York")

Output: 8, including the space.

Using LEN() for Data Quality

IF LEN(TRIM([Customer Name])) = 0 THEN
    "Blank Name"
ELSE
    "Name Available"
END

This calculated field identifies values that become empty after trimming ordinary leading and trailing spaces.

Practical Applications

• Checking the length of product codes.
• Identifying unexpectedly short or long text values.
• Finding blank-looking customer names.
• Checking whether an identifier has the expected number of characters.

10. LEFT() Function

LEFT() returns a specified number of characters from the beginning of a string. The returned text starts at the first character.

Syntax:

LEFT(string, number)

Example:

LEFT("Tableau", 3)

Output: Tab

Extracting a Product Prefix

Suppose Product Code contains ELEC-101-MUM. To extract the first four characters:

LEFT([Product Code], 4)

Output: ELEC

Example: Categorizing by Prefix

IF LEFT([Product Code], 4) = "ELEC" THEN
    "Electronics"
ELSEIF LEFT([Product Code], 4) = "FASH" THEN
    "Fashion"
ELSEIF LEFT([Product Code], 4) = "HOME" THEN
    "Home"
ELSE
    "Other"
END

This works when the source system follows the stated four-character prefix convention.

11. RIGHT() Function

RIGHT() returns a specified number of characters from the end of a string.

Syntax:

RIGHT(string, number)

Example:

RIGHT("Tableau", 3)

Output: eau

Extracting a Region Code

For the value ELEC-101-MUM:

RIGHT([Product Code], 3)

Output: MUM

Extracting the Last Four Characters of an Identifier

RIGHT([Customer ID], 4)

This can help display a shortened identifier. Avoid exposing sensitive identifiers unnecessarily in dashboards.

12. MID() Function

MID() extracts a substring beginning at a specified character position. Tableau counts the first character as position 1.

Syntax:

MID(string, start, [length])

• string: The text to search.
• start: The position at which extraction begins.
• length: Optional number of characters to return.

Example:

MID("Tableau", 2, 3)

Output: abl

Example without length:

MID("Tableau", 4)

Output: leau

Practical Example

Suppose an identifier is ORD-2026-105. To extract the year from its fixed character positions:

MID([Order Code], 5, 4)

Output: 2026

This fixed-position method assumes that the identifier structure remains consistent. If positions vary, SPLIT() or a regular expression may be more suitable.

13. FIND() Function

FIND() returns the position of a substring within a string. The first character is position 1. If the substring is not found, FIND() returns 0.

Syntax:

FIND(string, substring, [start])

Example:

FIND("Tableau Training", "Training")

Output: 9

Substring not found:

FIND("Tableau", "Python")

Output: 0

Using FIND() to Check a Position

IF FIND([Email], "@") > 0 THEN
    "Contains @"
ELSE
    "Missing @"
END

This checks whether the text contains an at-sign; it does not fully validate an email address.

14. FINDNTH() Function

FINDNTH() returns the position of a specified occurrence of a substring. Availability can depend on the data source.

Syntax:

FINDNTH(string, substring, occurrence)

Example:

FINDNTH("a-b-c-d", "-", 2)

Output: 5, because the second hyphen is at position 5.

Practical use: Locating the second separator in a structured identifier when the number and arrangement of separators are predictable.

15. CONTAINS() Function

CONTAINS() checks whether a string contains a specified substring. It returns TRUE or FALSE.

Syntax:

CONTAINS(string, substring)

Example:

CONTAINS("Tableau Training", "Training")

Output: TRUE

Filtering Products by Keyword

CONTAINS([Product Name], "Laptop")

This returns TRUE for product names containing the specified text when the comparison rules of the data source match the expected case behavior.

Case-Normalized Search

CONTAINS(LOWER([Product Name]), "laptop")

Converting the field to lowercase before checking can help make the search consistent across capitalization differences.

16. STARTSWITH() and ENDSWITH() Functions

16.1 STARTSWITH()

Checks whether a string starts with a specified substring. Leading whitespace is ignored by this function.

STARTSWITH("Tableau Training", "Tableau")

Output: TRUE

16.2 ENDSWITH()

Checks whether a string ends with a specified substring. Trailing whitespace is ignored.

ENDSWITH("report.csv", ".csv")

Output: TRUE

Practical Uses

• Identifying product codes with particular prefixes.
• Finding file names with a specified extension.
• Checking whether a category begins with an expected code.
• Creating Boolean filters for text-based conditions.

17. SPLIT() Function

SPLIT() separates a string into tokens using a delimiter and returns the requested token. It is especially useful for extracting first names, last names, email domains, and components of structured codes.

Syntax:

SPLIT(string, delimiter, token_number)

• string: The original text.
• delimiter: The character or text separating the tokens.
• token_number: The token to return. Positive numbers count from the left; negative numbers count from the right when supported by the data source.

Example 1: Splitting a Name

SPLIT("Rahul Sharma", " ", 1)

Output: Rahul

SPLIT("Rahul Sharma", " ", 2)

Output: Sharma

Example 2: Extracting a Product Category

Given ELEC-101-MUM:

SPLIT([Product Code], "-", 1)

Output: ELEC

SPLIT([Product Code], "-", 2)

Output: 101

SPLIT([Product Code], "-", 3)

Output: MUM

Example 3: Extracting an Email Domain

SPLIT([Email], "@", 2)

For [email protected], the result is example.com.

Example 4: Extracting the Last Token

SPLIT([Product Code], "-", -1)

For ELEC-101-MUM, this returns MUM when negative token indexing is supported by the connected data source.

Important: SPLIT() support and limits vary by data source. If a calculation fails, check the Tableau documentation for the specific connection and its token-number restrictions.

18. REPLACE() Function

REPLACE() searches for a specified substring and replaces its occurrences with another string. If the substring is not found, the original string is returned unchanged.

Syntax:

REPLACE(string, substring, replacement)

Example:

REPLACE("Mumbai-Maharashtra", "-", ", ")

Output: Mumbai, Maharashtra

Standardizing Categories

REPLACE([Product Name], "Mobile Phone", "Smartphone")

This replaces the specified phrase in the product name. Use it when the replacement rule is clear and appropriate for the data.

Removing a Known Character

REPLACE([Product Code], "-", "")

For ELEC-101-MUM, the result is ELEC101MUM.

19. SPACE() Function

SPACE() returns a string containing the specified number of ordinary spaces.

Syntax:

SPACE(number)

Example:

SPACE(3)

Output: a string containing three spaces.

Combining strings:

[First Name] + SPACE(1) + [Last Name]

This combines a first name and last name with one space between them. If either field can be NULL, handle that possibility separately to avoid unexpected NULL results.

20. ASCII() and CHAR() Functions

20.1 ASCII()

ASCII() returns the ASCII code for the first character of a string.

ASCII("A")

Output: 65

20.2 CHAR()

CHAR() returns the character associated with an ASCII code.

CHAR(65)

Output: A

These functions can be useful when investigating basic character codes or working with data transformations that require character-code operations. Their behavior and character coverage should be checked for the relevant data source and encoding.

21. Regular Expression String Functions

Regular expressions, often called regex, describe text patterns. Tableau provides REGEXP functions for extracting, matching, and replacing text patterns where supported by the data source.

21.1 REGEXP_REPLACE()

Replaces text that matches a regular expression pattern.

REGEXP_REPLACE([Product Code], "-", "")

For ELEC-101-MUM, this produces ELEC101MUM.

21.2 REGEXP_EXTRACT()

Extracts a substring matching a capturing group in a regular expression.

REGEXP_EXTRACT([Order Code], "ORD-([0-9]+)")

For ORD-105, this returns 105.

21.3 REGEXP_MATCH()

Checks whether a substring matches a regular expression pattern and returns a Boolean result.

REGEXP_MATCH([Order Code], "ORD-[0-9]+")

This can check whether the value contains a substring that follows the stated order-code pattern. To validate the entire string rather than a substring, use anchors where supported, such as ^ORD-[0-9]+$.

21.4 REGEXP_EXTRACT_NTH()

Extracts a specified capturing group from a regular expression match.

REGEXP_EXTRACT_NTH([Full Name], "([A-Za-z]+) ([A-Za-z]+)", 2)

For a matching two-part name such as Rahul Sharma, this returns the second captured group, Sharma.

Note: Regex support and syntax can vary across Tableau connectors and databases. Test calculations with representative values before using them in production dashboards.

22. Combining Multiple String Functions

String functions become more powerful when combined in a single calculated field.

Example 1: Clean and Format Customer Names

PROPER(TRIM([Customer Name]))

Input: rahul sharma

Output: Rahul Sharma

Example 2: Normalize City Names

UPPER(TRIM([City]))

Input: mumbai

Output: MUMBAI

Example 3: Extract and Standardize a Region Code

UPPER(TRIM(RIGHT([Product Code], 3)))

Input: ELEC-101-mum

Output: MUM

Example 4: Check for an Email Domain

IF CONTAINS(LOWER(TRIM([Email])), "@example.com") THEN
    "Example Domain"
ELSE
    "Other Domain"
END

This checks whether the cleaned lowercase text contains the specified domain substring. For stricter domain identification, extract the domain and compare it to the exact expected value.

Example 5: Classify Product Codes

IF LEFT(UPPER(TRIM([Product Code])), 4) = "ELEC" THEN
    "Electronics"
ELSEIF LEFT(UPPER(TRIM([Product Code])), 4) = "FASH" THEN
    "Fashion"
ELSEIF LEFT(UPPER(TRIM([Product Code])), 4) = "HOME" THEN
    "Home"
ELSE
    "Other"
END

This calculation cleans the code, checks its prefix, and assigns a category.

23. Creating a Calculated Field in Tableau

1. Open Tableau Desktop or Tableau Cloud with authoring access.
2. Connect to your dataset, such as an Excel file or a database.
3. Locate the Data pane on the left side of the worksheet.
4. Open the Data pane menu and select Create Calculated Field.
5. Give the field a meaningful name, such as Clean Customer Name.
6. Enter the formula in the calculation editor.
7. Review the validation message and correct any syntax errors.
8. Click Apply or OK, depending on the interface.
9. Drag the new calculated field into Rows, Columns, Marks, Filters, or the relevant worksheet area.
10. Verify the output using several original data values.

Example Calculated Field

Field name: Clean Customer Name

PROPER(TRIM([Customer Name]))

The new field can be used as a dimension in a customer table, chart, or dashboard.

24. Using String Functions in Visualizations

Example A: Customer List

Create a calculated field named Formatted Customer Name:

PROPER(TRIM([Customer Name]))

Drag the new field to Rows and add sales to Text to show cleaned customer names alongside their sales.

Example B: Product Category Chart

Create a calculated field named Product Category:

UPPER(SPLIT([Product Code], "-", 1))

Drag Product Category to Columns and Sales to Rows to compare sales by category.

Example C: Email Domain Analysis

Create a field named Email Domain:

LOWER(SPLIT(TRIM([Email]), "@", 2))

Place Email Domain on Rows and a customer count on Columns to examine the distribution of email domains. Confirm that source values follow the expected email format before relying on the results.

25. Common Errors and Troubleshooting

26. Best Practices for String Functions

• Use meaningful calculated-field names, such as Clean City or Email Domain.
• Apply TRIM() when leading and trailing spaces may be present.
• Use UPPER() or LOWER() consistently when standardizing text for comparisons.
• Do not assume that PROPER() preserves names, acronyms, or brand-specific capitalization.
• Use LEFT(), RIGHT(), and MID() only when character positions are reliable.
• Use SPLIT() when a consistent delimiter separates meaningful components.
• Use regular expressions for complex patterns, after confirming connector support.
• Check NULL values and malformed records before relying on calculated fields.
• Test calculations on unusual values, not just clean sample records.
• Use Tableau Prep or upstream data cleaning for extensive, reusable transformations when appropriate.
• Remember that string functions transform values for analysis; they do not automatically change the original source data.

27. Practical Project: Customer and Product Data Cleaning Dashboard

Project objective: Clean customer names, standardize cities, extract product categories, and analyze email domains using Tableau string functions.

Sample Input Data

Step 1: Create Clean Customer Name

PROPER(TRIM([Customer Name]))

Step 2: Create Standardized City

UPPER(TRIM([City]))

Step 3: Create Product Category

CASE UPPER(SPLIT([Product Code], "-", 1))
WHEN "ELEC" THEN "Electronics"
WHEN "FASH" THEN "Fashion"
WHEN "HOME" THEN "Home"
ELSE "Other"
END

Step 4: Create Email Domain

LOWER(SPLIT(TRIM([Email]), "@", 2))

Step 5: Build the Dashboard

1. Create a customer table showing the cleaned customer name, standardized city, email domain, and sales.
2. Create a bar chart comparing sales by product category.
3. Create a chart showing the number of customers by email domain.
4. Add filters for standardized city and product category.
5. Use clear titles and tooltips to explain the cleaned fields.
6. Compare the results with the original source values to confirm that the transformations are correct.

Expected Learning Outcomes

• Customer names display consistently.
• City names use a common capitalization format.
• Product codes are converted into meaningful categories.
• Email domains can be grouped for basic distribution analysis.
• The dashboard demonstrates how calculated fields support data preparation and analysis.

28. Practice Exercises

1. Convert the text "tableau desktop" into uppercase.
2. Convert "SALES REPORT" into lowercase.
3. Format " rahul sharma " using TRIM() and PROPER().
4. Extract the first three characters from "MUMBAI".
5. Extract the last three characters from "ELEC-101-MUM".
6. Extract "101" from "ELEC-101-MUM" using SPLIT().
7. Find the position of "@" in an email address.
8. Check whether a product name contains the word "Laptop".
9. Replace hyphens in a product code with underscores.
10. Create a calculated field that identifies whether a product code begins with "ELEC".
11. Create an email-domain field using SPLIT().
12. Build a worksheet that compares sales by the extracted product category.

29. Interview Questions and Answers

Q1. What are string functions in Tableau?

Answer: String functions are calculation functions used to manipulate, search, extract, standardize, or replace text values in a dataset.

Q2. What is the difference between UPPER() and LOWER()?

Answer: UPPER() converts letters to uppercase, while LOWER() converts letters to lowercase.

Q3. What is the purpose of PROPER()?

Answer: PROPER() capitalizes the first letter of each word and converts the remaining letters to lowercase. It may not preserve special brand or name formatting.

Q4. What is the difference between TRIM(), LTRIM(), and RTRIM()?

Answer: TRIM() removes leading and trailing spaces, LTRIM() removes leading spaces, and RTRIM() removes trailing spaces.

Q5. What does LEN() return?

Answer: LEN() returns the length of a string, including spaces that are part of the string.

Q6. What is the difference between LEFT() and RIGHT()?

Answer: LEFT() extracts characters from the beginning of a string, whereas RIGHT() extracts characters from the end.

Q7. What is MID() used for?

Answer: MID() extracts text from a specified starting position and can optionally limit the number of returned characters.

Q8. How does FIND() work?

Answer: FIND() returns the position of a substring. It returns 0 when the substring is not found.

Q9. What is the difference between FIND() and CONTAINS()?

Answer: FIND() returns a numeric position or 0, while CONTAINS() returns TRUE or FALSE.

Q10. What is SPLIT() used for?

Answer: SPLIT() returns a token from text separated by a delimiter. It can extract parts of names, product codes, and email addresses.

Q11. What is the purpose of REPLACE()?

Answer: REPLACE() substitutes a specified substring with another string.

Q12. How can you standardize customer names?

Answer: Use PROPER(TRIM([Customer Name])) to remove ordinary leading and trailing spaces and standardize capitalization.

Q13. What is the purpose of regular expression functions?

Answer: They can match, extract, or replace text patterns using regular expressions, subject to data-source support.

Q14. Can string functions be used in dashboards?

Answer: Yes. Calculated fields created with string functions can be used in visualizations, filters, labels, tooltips, and other worksheet components.

Q15. Do string functions modify the original data source?

Answer: A Tableau calculated field transforms values for use in analysis but does not, by itself, rewrite the original source data.

30. Quick Revision Checklist

• ☐ Understand string data and calculated fields.
• ☐ Use UPPER(), LOWER(), and PROPER() to format text.
• ☐ Use TRIM(), LTRIM(), and RTRIM() to remove ordinary leading or trailing spaces.
• ☐ Use LEN() to count characters.
• ☐ Use LEFT(), RIGHT(), and MID() to extract text.
• ☐ Use FIND() and FINDNTH() to locate substrings.
• ☐ Use CONTAINS(), STARTSWITH(), and ENDSWITH() to test text.
• ☐ Use SPLIT() to extract delimiter-separated tokens.
• ☐ Use REPLACE() to substitute known text.
• ☐ Understand ASCII() and CHAR().
• ☐ Explore regex functions for pattern-based text operations.
• ☐ Create calculated fields and validate results in worksheets.
• ☐ Check connector compatibility, NULL values, and inconsistent source formats.

31. Conclusion

String functions are essential for preparing text data in Tableau. Functions such as UPPER(), LOWER(), PROPER(), TRIM(), LEFT(), RIGHT(), MID(), FIND(), SPLIT(), and REPLACE() help make datasets more consistent and useful for analysis. Regular expression functions provide additional flexibility for pattern-based transformations when supported by the data source.

Practice these functions on real customer, product, and order datasets. Build calculated fields, test them on inconsistent values, and use the results in charts and dashboards to develop practical Tableau data-cleaning skills.

Continue Learning: Explore JustAcademy Tableau Training | Register for a Tableau Course Demo

Official Reference: Tableau String Functions Documentation